SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
AND list_price BETWEEN '1000000' AND '99999999'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Convenient location, optional 1-floor living, and extensive, thoughtful updates come together in this fully move-in ready home. The main floor includes a large and inviting kitchen with newer stainless steel appliances including a double oven and Wolf range, Crown Point cabinetry, and marble countertops, a separate dining room, living room with fireplace, 2 bedrooms that share a full bath, plus a primary bedroom with updated 3/4 en-suite bath. The lower walkout level features another bedroom, full bath, large playroom or den with Hearthstone wood stove, office space, laundry and workshop, plus plenty of extra storage space. Outside you'll find a newly resurfaced Trex deck from which there are lovely seasonal mountain views, a fenced yard with raised garden beds and mature plantings, and a paved circular drive. Recent updates are numerous and a full list is available on request but energy efficiency was a priority. A fully-owned 10-megawatt solar panel system, an electric heat pump hot water heater, a Level-2 CCS EV charger and Anderson 400 Low-E windows are some highlights. Located almost equidistant to Dartmouth College, DHMC, West Lebanon, and the Miracle, commuting and shopping are a breeze. SHOWINGS BEGIN AT OPEN HOUSE SATURDAY, APRIL 26 10:30-1:30.
Description:Come to Etna and make your new home on Dogford Road. This contemporary home has it all. From a large open kitchen/living/dining room combination family and guests can disperse to any number of getaways in this multi level home. Enjoy the abundant wildlife, songbirds, hooting owls, and a crows nest where you can escape amongst the trees. Two bedrooms, a full bathroom and workout area complete the lower walk out area. The main floor has a vaulted ceiling along with a generous full length deck. Enjoy great natural light from all levels of this home. The house sits up high so you really feel the privacy afforded by the trees, particularly at the rear. The primary bedroom is oversized and and has it's own ensuite bathroom. The other bedroom on this level is served by a three quarter bath and then via a spiral stairwell you can escape the madding crowd and vanish up to the aforementioned crows nest with it's little balcony. Read, craft, nap-whatever-this is a really cool space. The 4.2 acres is mixed with some wetlands at the back, some very nice terracing near the house and also blueberry bushes are a plenty. This is a really lovely property and could be your next home. Come and check out 420 Dogford Road you won't be disappointed. Delayed showings begin with an Open House on Saturday April 26th, 2025 between 11:00 AM - 1:00 PM.
Description:This 4 bedroom, 3.5 bath contemporary is beautifully situated on a corner 1.97+/- acre lot in the village of Etna in Hanover. The main floor features an open cherry kitchen with granite counters, lots of storage and light filled dining area that leads to a brand new deck. The living room with it's cozy woodstove and soaring catherdral ceilings is perfect for gathering and entertaining and the primary suite with a walk through closet and a full bath is nicely nestled on the backside of the home. Upstairs features 3 bedrooms, a full bath and a loft space overlooking the living room. In the walkout basement you have a mudroom off the 2 car garage, big family room, 3/4 bath, laundry and a bonus room for exercise equipment and all your outdoor gear. Love to bike and hike?! Numerous trails within super close proximity - Trescott trails, AT and more! A great house in a great location! Delayed showings start on Saturday, March 29th at the Open House from 11:00-1:00.
Description:Sited on a southeast-facing ridge in the hills of Plainfield, this extraordinary estate seamlessly blends elegance, solitude, and natural beauty. The private 103 acres of pristine woodlands with multiple ponds, meandering hiking and riding trails, and views of local hills and distant mountains, offers the ultimate retreat while being just minutes from Dartmouth College, DHMC, I-89, and I-91. Its location provides both tranquility and convenient access to the best of the Upper Valley, Boston, and beyond. The residence is a unique fusion of Tuscan-inspired design, Italian elegance, and traditional New England craftsmanship. Recently renovated with meticulous attention to detail, the home features a sun-drenched, flexible floor plan with five spacious bedrooms, multiple additional spaces to use as you see fit, and a guest wing. The redesigned eat-in kitchen and breakfast nook showcase modern updates, while radiant heat, wood, and pellet stoves ensure cozy warmth. Notable features such as the observation tower provide unique spaces to relax, take in the spectacular views, and stargaze. The property is designed for both leisure and function and includes a 2-bay attached garage, 1-bay under, 3-bay detached barn, and more. There's ample space for your hobbies and all the gear. Whether exploring the trails, enjoying the ponds, or hosting in the expansive living spaces, this retreat delivers a lifestyle of unmatched serenity, privacy, luxury, and sophistication.
Description:Marvellous contemporary cape in move-in condition with fabulous gleaming hardwood floors throughout the main level. Open first floor has spacious kitchen, dining room, living room, mudroom, office and 1/2 bath/laundry. Second floor has 3 bedrooms, 2 full bathrooms. Separate suite, accessed from mudroom has large living room or home office, bedroom, and 3/4 bath. This residential neighborhood location makes for quick and easy commuting to the medical center, without driving through Hanover, or to the College. A great one! Showings start at Open House Saturday, Jan 4, 10am-12 and Sunday, Jan 5, 2-4pm